OpenEdge Data Management:<br />SQL Reference OpenEdge SQL reserved words

Reserved words are keywords. You can use keywords as identifiers in SQL statements only if you delimit them with double quotation marks. If you use keywords without delimiting them, the statement generates one of the following errors:

error(-20003): Syntax error error(-20049): Keyword used for a name

Table 1: OpenEdge SQL reserved words
`A`	`ABS`	`ACOS`	`ADD`
`ADD_MONTHS`	`AFTER`	`ALL`	`ALTER`
`AN`	`AND`	`ANY`	`AREA`
`ARRAY`	`AS`	`ASC`	`ASCII`
`ASIN`	`ATAN`	`ATAN2`	`AVG`
`BEFORE`	`BEGIN`	`BETWEEN`	`BIGINT`
`BINARY`	`BIND`	`BINDING`	`BIT`
`BLOB`	`BY`	`CALL`	`CASCADE`
`CASE`	`CAST`	`CEILING`	`CHAR`
`CHAR_LENGTH`	`CHARACTER`	`CHARACTER_LENGTH`	`CHARTOROWID`
`CHECK`	`CHR`	`CLEANUP`	`CLOB`
`CLOSE`	`CLUSTERED`	`COALESCE`	`COLGROUP`
`COLLATE`	`COMMIT`	`COMPLEX`	`COMPRESS`
`CONCAT`	`CONNECT`	`CONSTRAINT`	`CONTAINS`
`CONTINUE`	`CONVERT`	`COS`	`COUNT`
`CREATE`	`CROSS`	`CURDATE`	`CURRENT`
`CURRVAL`	`CURSOR`	`CURTIME`	`CVAR`
`CYCLE`	`DATABASE`	`DATAPAGES`	`DATE`
`DAYNAME`	`DAYOFMONTH`	`DAYOFWEEK`	`DAYOFYEAR`
`DB_NAME`	`DBA`	`DEC`	`DECIMAL`
`DECLARATION`	`DECLARE`	`DECODE`	`DEFAULT`
`DEFINITION`	`DEGREES`	`DELETE`	`DESC`
`DESCRIBE`	`DESCRIPTOR`	`DHTYPE`	`DIFFERENCE`
`DISTINCT`	`DOUBLE`	`DROP`	`EACH`
`ELSE`	`END`	`ESCAPE`	`EXCLUSIVE`
`EXEC`	`EXECUTE`	`EXISTS`	`EXIT`
`EXP`	`EXPLICIT`	`EXTENT`	`FETCH`
`FIELD`	`FILE`	`FLOAT`	`FLOOR`
`FOR`	`FOREIGN`	`FOUND`	`FROM`
`FULL`	`GO`	`GOTO`	`GRANT`
`GREATEST`	`GROUP`	`HASH`	`HAVING`
`HOUR`	`IDENTIFIED`	`IFNULL`	`IMMEDIATE`
`IN`	`INDEX`	`INDEXPAGES`	`INDICATOR`
`INITCAP`	`INNER`	`INOUT`	`INPUT`
`INSERT`	`INSTR`	`INT`	`INTEGER`
`INTERFACE`	`INTERSECT`	`INTO`	`IS`
`JOIN`	`KEY`	`LAST_DAY`	`LCASE`
`LEAST`	`LEFT`	`LENGTH`	`LIKE`
`LINK`	`LIST`	`LOCATE`	`LOCK`
`LOG`	`LOG10`	`LONG`	`LOWER`
`LPAD`	`LTRIM`	`LVARBINARY`	`LVARCHAR`
`MAIN`	`MAX`	`METADATA_ONLY`	`MIN`
`MINUS`	`MINUTE`	`MOD`	`MODE`
`MODIFY`	`MONEY`	`MONTH`	`MONTHNAME`
`MONTHS_BETWEEN`	`NAME`	`NATIONAL`	`NATURAL`
`NCHAR`	`NEWROW`	`NEXT_DAY`	`NEXTVAL`
`NOCOMPRESS`	`NOT`	`NOW`	`NOWAIT`
`NULL`	`NULLIF`	`NULLVALUE`	`NUMBER`
`NUMERIC`	`NVL`	`OBJECT_ID`	`ODBC_CONVERT`
`ODBCINFO`	`OF`	`OLDROW`	`ON`
`OPEN`	`OPTION`	`OR`	`ORDER`
`OUT`	`OUTER`	`OUTPUT`	`PCTFREE`
`PI`	`POWER`	`PRECISION`	`PREFIX`
`PREPARE`	`PRIMARY`	`PRIVILEGES`	`PROCEDURE`
`PUBLIC`	`QUARTER`	`RADIANS`	`RAND`
`RANGE`	`RAW`	`READPAST`	`REAL`
`RECORD`	`REFERENCES`	`REFERENCING`	`RENAME`
`REPEAT`	`REPLACE`	`RESOURCE`	`RESTRICT`
`RESULT`	`RETURN`	`REVOKE`	`RIGHT`
`ROLLBACK`	`ROW`	`ROWID`	`ROWIDTOCHAR`
`ROWNUM`	`RPAD`	`RTRIM`	`SCHEMA`
`SEARCHED_CASE`	`SECOND`	`SECTION`	`SELECT`
`SEQUENCE`	`SERVICE`	`SET`	`SHARE`
`SHORT`	`SIGN`	`SIMPLE_CASE`	`SIN`
`SIZE`	`SMALLINT`	`SOME`	`SOUNDEX`
`SPACE`	`SQL`	`SQL_BIGINT`	`SQL_BINARY`
`SQL_BIT`	`SQL_CHAR`	`SQL_DATE`	`SQL_DECIMAL`
`SQL_DOUBLE`	`SQL_FLOAT`	`SQL_INTEGER`	`SQL_LONGVARBINARY`
`SQL_LONGVARCHAR`	`SQL_NUMERIC`	`SQL_REAL`	`SQL_SMALLINT`
`SQL_TIME`	`SQL_TIMESTAMP`	`SQL_TINYINT`	`SQL_TSI_DAY`
`SQL_TSI_FRAC_SECO ND`	`SQL_TSI_HOUR`	`SQL_TSI_MINUTE`	`SQL_TSI_MONTH`
`SQL_TSI_QUARTER`	`SQL_TSI_SECOND`	`SQL_TSI_WEEK`	`SQL_TSI_YEAR`
`SQL_VARBINARY`	`SQL_VARCHAR`	`SQLERROR`	`SQLWARNING`
`SQRT`	`START`	`STATEMENT`	`STATISTICS`
`STOP`	`STORAGE_ATTRIBUTE S`	`STORAGE_MANAGER`	`STORE_IN_SQLENG`
`SUBSTR`	`SUBSTRING`	`SUFFIX`	`SUM`
`SUSER_NAME`	`SYNONYM`	`SYSDATE`	`SYSTIME`
`SYSTIMESTAMP`	`TABLE`	`TAN`	`THEN`
`TIME`	`TIMEOUT`	`TIMESTAMP`	`TIMESTAMPADD`
`TIMESTAMPDIFF`	`TINYINT`	`TO`	`TO_CHAR`
`TO_DATE`	`TO_NUMBER`	`TO_TIME`	`TO_TIMESTAMP`
`TPE`	`UCASE`	`UID`	`UNION`
`TRANSACTION`	`TRANSLATE`	`TRIGGER`	`TYPE`
`UNIQUE`	`UNSIGNED`	`UPDATE`	`UPPER`
`USER`	`USER_ID`	`USER_NAME`	`USING`
`UUID`	`VALUES`	`VARBINARY`	`VARCHAR`
`VARIABLES`	`VARYING`	`VERSION`	`VIEW`
`WEEK`	`WHEN`	`WHENEVER`	`WHERE`
`WITH`	`WORK`	`YEAR`	`—`